LOAD DATA 
 INFILE lote.dat
 TRUNCATE
 CONTINUEIF NEXT(1:1) = '#'
 INTO TABLE LOTE
 FIELDS TERMINATED BY '|'
 TRAILING NULLCOLS (
   chil 	NULLIF chil = BLANKS,
   chip 	NULLIF chip = BLANKS,
   area,
   chip_ori 	NULLIF chip_ori = BLANKS,
   valorm2,
   fec_tram DATE "YYYYMMDD",
   ID_FUN,
   GEO COLUMN OBJECT 
   (
     SDO_GTYPE       INTEGER EXTERNAL, 
     SDO_ELEM_INFO   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL), 
     SDO_ORDINATES   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL) 
   )
)
